Columbia Basin Fish and Wildlife Program Columbia Basin Fish and Wildlife Program
SOW Report
Contract 20620 REL 32: 2013-001-00 EXP WORK PLAN FOR FISH DATA PRODUCT
Project Number:
Title:
Fish Data Products Technical Services
Stage:
Implementation
Area:
Province Subbasin %
Basinwide - 100.00%
Contract Number:
20620 REL 32
Contract Title:
2013-001-00 EXP WORK PLAN FOR FISH DATA PRODUCT
Contract Continuation:
Previous: Next:
n/a
Contract Status:
Closed
Contract Description:
[This contract is the continuation of a subset of tasks previously accomplished under the project: #1989-062-01]

Through this technical services contract, fish and wildlife data required for Council and Bonneville reporting needs will be be compiled, filtered, extracted, organized, formatted, and made available electronically via the Council's website. The efforts that will be implemented can be categorized under one of the following four broad service types:

1: Identify and migrate the pertinent content of the SOTR website for Council and Bonneville reporting needs. Rebrand graphics and data portals to merge content seamlessly for Council and Bonneville use.
2: Finalize identification of information to populate the FWIs supporting the Council’s HLIs, Council’s reports to Congress and to the Governors, indicator graphics for the CBFish.org website, and Bonneville’s reports. Assist Council and Bonneville staff in setting up more efficient data sharing with regional data portal (e.g., CBFish.org) and data delivery (e.g., StreamNet) systems to reduce effort in accessing and updating this information.
3. Continue to incorporate automated access to information (data, indicators, etc.) from regional databases and other data sources to enhance the efficiency of informing Council and Bonneville reporting needs and to ensure the information included in reports is current and relevant. Incorporate modifications/enhancements in information portrayed (data, indicators, graphic type, etc) as requested for addressing Council and Bonneville reporting needs.
4. Produce graphics and maps as requested for Council and Bonneville reporting needs. Approximately 1-3 web-based graphics per quarter can be accomplished under this contract. The total number of graphics and maps per quarter will be determined by the complexity of the request.  

The implementation strategy for the Fish Data Products Technical Services Work Plan is based on a two-phased approach that will span over a two-year period. This contract and SOW represents the first year of actions with an understanding that an additional year will be needed to fully address the Council's suite of expected deliverables in the Work Plan. The available funding level under this contract provides for 0.75 FTE.  In order to fulfill the deliverables outlined in this contract, the number of service- related requests will be limited. Depending on the complexity, this project can produce approximately 1-3  HLI/FWI graphics and 1-3 ISAB/Council/BPA graphics per quarter; for a total of approximately 8-24 web-based graphics that could be produced during this contract year.
Account Type(s):
Expense
Contract Start Date:
04/01/2013
Contract End Date:
04/30/2014
Current Contract Value:
$200,000
Expenditures:
$200,000

* Expenditures data includes accruals and are based on data through 31-Mar-2024.

BPA COR:
Env. Compliance Lead:
Work Order Task(s):
Contract Type:
Release
Pricing Method:
Cost Reimbursement (CNF)
Click the map to see this Contract’s location details.

No photos have been uploaded yet for this Contract.

Full Name Organization Write Permission Contact Role Email Work Phone
Jann Eckman Columbia Basin Fish and Wildlife Foundation No Administrative Contact jann.eckman@cbfwa.org (503) 229-0191
Marchelle Foster Bonneville Power Administration Yes COR mmfoster@bpa.gov (503) 230-3446
Nancy Leonard Northwest Power and Conservation Council Yes Supervisor nleonard@nwcouncil.org (503) 222-5161
Binh Quan QW Consulting, LLC Yes Technical Contact binh.quan@qwconsult.com (503) 477-4310
Donald Rose Bonneville Power Administration Yes Env. Compliance Lead dlrose@bpa.gov (503) 230-3796
Russell Scranton Bonneville Power Administration No Interested Party rwscranton@bpa.gov (503) 230-4412
Jason Sweet Bonneville Power Administration Yes F&W Approver jcsweet@bpa.gov (503) 230-3349
Kristi Van Leuven Bonneville Power Administration Yes Contracting Officer kjvleuven@bpa.gov (503) 230-3605
Neil Ward Columbia Basin Fish and Wildlife Foundation Yes Contract Manager neil.ward@qwconsult.com (503) 477-4310


Viewing of Work Statement Elements

Deliverable Title WSE Sort Letter, Number, Title Start End Concluded
Provide Regional Coordination A: 189. Facilitate/coordinate fish & wildlife manager technical discussions for data reporting 03/31/2014 09/30/2013
Information sharing and product dissemination B: 99. Information sharing and product dissemination 03/31/2014 09/30/2013
Status and Trends data updates C: 160. Manage and maintain fish and wildlife database for Council Program Amendment 03/31/2014 09/30/2013
Compile HLI and FWI data D: 160. Manage and maintain resident fish HLI and FWI database 07/01/2013 07/01/2013
Monthly website updates E: 160. Manage fish and wildlife system (website & database) to support existing links on Council website 03/31/2014 09/30/2013
Program and Amendment graphic displays F: 161. Provide Council/Progam/ISAB/BPA report specific data and graphic displays 03/31/2014 09/30/2013
Provide HLI and FWI Graphics G: 161. Provide resident fish HLI and FWI data and interactive graphic displays 07/01/2013 07/01/2013
Transition Plan H: 159. Transition planning and preparation 03/31/2014 09/30/2013
Fulfill all administrative tasks with quality products and in a timely manner. I: 119. Manage Fish Data project activities 03/31/2014 09/30/2013

Viewing of Implementation Metrics
Viewing of Environmental Metrics Customize

Primary Focal Species Work Statement Elements
Chinook (Oncorhynchus tshawytscha) - All Populations
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Chum (Oncorhynchus keta) - Columbia River ESU (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Coho (Oncorhynchus kisutch) - Lower Columbia River ESU (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Coho (O. kisutch) - Unspecified Population
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Cutthroat Trout, Coastal (Oncorhynchus clarkii clarkii) - All Anadromous Populations
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Sockeye (Oncorhynchus nerka) - All Populations
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Steelhead (Oncorhynchus mykiss) - All Populations
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Lamprey, Pacific (Entosphenus tridentata)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Sturgeon, White (A. transmontanus) - Lower Columbia River
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 2 instances of WE 161 Disseminate Raw/Summary Data and Results
Bass, Largemouth (Micropterus salmoides)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Bass, Smallmouth (M. dolomieu)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Burbot (Lota lota)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Catfish (Ictalurus spp.) [OBSOLETE]
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Chub, Oregon (Oregonichthys crameri) (Endangered through FY2015)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Crappie, Black (Pomoxis nigromaculatus) [OBSOLETE]
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Cutthroat Trout, Coastal (O. clarkii clarkii)- Resident Populations
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Cutthroat Trout, Lahontan (O. c. henshawi) (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Cutthroat Trout, Westslope (O. c. lewisi)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Cutthroat Trout, Yellowstone (O. c. bouvieri)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Kokanee (Oncorhynchus nerka)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Pike, Northern (Esox lucius) [OBSOLETE]
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Sturgeon, White (Acipenser transmontanus) - All Populations except Kootenai R. DPS
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Sturgeon, White (A. transmontanus) - Kootenai River DPS (Endangered)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Trout, Brown (Salmo trutta) [OBSOLETE]
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Trout, Brook (Salvelinus fontinalis)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Trout, Bull (S. confluentus) (Threatened)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Trout, Lake (S. namaycush) [OBSOLETE]
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Trout, Rainbow (Oncorhynchus mykiss)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Trout, Interior Redband (O. mykiss gairdnerii)
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results
Walleye (Stizostedion vitreum) [OBSOLETE]
  • 1 instance of WE 159 Transfer/Consolidate Regionally Standardized Data
  • 1 instance of WE 161 Disseminate Raw/Summary Data and Results

Sort WE ID WE Title NEPA NOAA USFWS NHPA Has Provisions Inadvertent Discovery Completed
A 189 Facilitate/coordinate fish & wildlife manager technical discussions for data reporting 04/01/2013
B 99 Information sharing and product dissemination 04/01/2013
C 160 Manage and maintain fish and wildlife database for Council Program Amendment 04/01/2013
D 160 Manage and maintain resident fish HLI and FWI database 04/01/2013
E 160 Manage fish and wildlife system (website & database) to support existing links on Council website 04/01/2013
F 161 Provide Council/Progam/ISAB/BPA report specific data and graphic displays 04/01/2013
G 161 Provide resident fish HLI and FWI data and interactive graphic displays 04/01/2013
H 159 Transition planning and preparation 04/01/2013
I 119 Manage Fish Data project activities 04/01/2013
J 185 Periodic Status Reports for BPA 04/01/2013
K 132 Submit Progress Report for the period (Apr 2013 to Mar 2014) 04/01/2013